| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
| BrandName (FK)(PK) | A unique name to denote a class of ITEMs as a product. The brand can include private label ITEMs. | NM_BRN | Name | varchar(40) | Brand(ID_BRN) |
| SubBrandSequenceNumber (PK) | A sequence number that identifies a subbrand within a brand. | AI_SUB_BRN | LineNumber | smallint | |
| SubBrandName | The name of a subcomponent of a brand. As an example, if a Brand were "Super Cola", the subbrand might be "Super Cola Light". | NM_SUB_BRN | Name | varchar(40) | |
| SubBrandDescription | A short description of a subbrand. | DE_SUB_BRN | DescriptionShort | varchar(255) | |